Step by Step Instructions to reproduce solution from scratch
8
Step by Step Instructions to reproduce solution from scratch
https://1drv.ms/u/s!AqynLAPPbtjviP1M22nlf-9p0L0LXg?e=C2gzpe
- Open SQL Server and make sure it's running
- Create data base: DataWarehouse
- Double click on the link above.This will automatically open a SSMS (Sql Server Management Studio) file with data script
- Make sure it is connected to DataWarehouse
- Execute the script. This will create and populate all tables
· 
LOAD DATA INTO POWER BI
- Click on Get Data
- Select SQL Server
- Select DataWarehouse
- Select Tables to be imported: Dim_Agent, Dim_Channel, Dim_Status, Dim_Ticket and Fact_Zendesk
- Click on load to Load selected tables
Create Association Between The Tables
Follow the instructions below to create association between the Fact Table and the Dimension Tables.
- Click on model tab to begin creating association
- Drag Status Key Column in Dim_Status Table to join Status Key Column in Facts_Zendesk Table to create Associate between the 2 tables
- Repeat the same process by dragging and joining common columns between Dim_Agent,Dim_Ticket, Dim_Channel and Facts_Zendesk Tables to Create association between them.
- Drag the date Column in the Date table to join the Date Column in Dim_ticket
Step by Step Instructions to reproduce solution from scratch
8
Step by Step Instructions to reproduce solution from scratch
https://1drv.ms/u/s!AqynLAPPbtjviP1M22nlf-9p0L0LXg?e=C2gzpe
- Open SQL Server and make sure it's running
- Create data base: DataWarehouse
- Double click on the link above.This will automatically open a SSMS (Sql Server Management Studio) file with data script
- Make sure it is connected to DataWarehouse
- Execute the script. This will create and populate all tables
· LOAD DATA INTO POWER BI
- Click on Get Data
- Select SQL Server
- Select DataWarehouse
- Select Tables to be imported: Dim_Agent, Dim_Channel, Dim_Status, Dim_Ticket and Fact_Zendesk
- Click on load to Load selected tables
Create Association Between The Tables
Follow the instructions below to create association between the Fact Table and the Dimension Tables.
- Click on model tab to begin creating association
- Drag Status Key Column in Dim_Status Table to join Status Key Column in Facts_Zendesk Table to create Associate between the 2 tables
- Repeat the same process by dragging and joining common columns between Dim_Agent,Dim_Ticket, Dim_Channel and Facts_Zendesk Tables to Create association between them.
- Drag the date Column in the Date table to join the Date Column in Dim_ticket
-